All type of date to a text formatted date in excel

 



=TEXT(A1,"yyyy-mm-dd")


Comments

Post a Comment

Popular posts from this blog

Temporary Workaround for cURL DNS Resolution Failure Using CURLOPT_RESOLVE

 Temporary Workaround for cURL DNS Resolution Failure Using CURLOPT_RESOLVE ========================================================================== If you're using PHP's cURL functions and encounter the dreaded error: ``` cURL Error: Could not resolve host: example.com cURL Error Code: 6 ``` It means your server is **unable to resolve the domain name to an IP address** — usually a DNS issue. While fixing your DNS configuration is ideal, sometimes you need an **immediate workaround** — especially in production or during development. The Workaround: CURLOPT_RESOLVE ------------------------------- PHP’s cURL supports a powerful option called `CURLOPT_RESOLVE`. It allows you to **manually specify the IP address** for a domain, bypassing DNS resolution altogether. ### Basic Syntax ```php curl_setopt($ch, CURLOPT_RESOLVE, ['example.com:443:93.184.216.34']); ``` - `example.com` → domain name you’re accessing - `443` → port number (use `80` for HTTP or `443` for HTTPS) - `93...
Read more

Hosting a Laravel 11 project on cPanel shared hosting

  Hosting a Laravel 11 project on cPanel shared hosting involves several steps since Laravel is built to work with a virtual host setup (like localhost with public/ as root), but cPanel typically uses public_html/ as the root directory. Here’s a full guide to help you: ✅ Prerequisites Laravel 11 project ready on your local machine. cPanel access (via your hosting provider). PHP version on server must be PHP 8.2+ . Composer installed on server (optional but helpful). MySQL database (if needed) created in cPanel. 📁 Step-by-Step Hosting Guide 1. Structure Your Project for cPanel By default, Laravel uses public/ as the web root. But cPanel uses public_html/ . So you need to move the contents of Laravel's public/ folder into public_html/ , and update paths accordingly. Let’s say your project folder is called laravel11app . Option A: Simple Adjustment (Recommended for shared hosting) Compress your entire Laravel project , excluding the vendor folder (optiona...
Read more