Formula That Makes Date Equal A Value In Another Cell

[TMILJVIPM]

I'm looking for some help with a formula that when I have a date entered in cell G1 then cell N1will populate to 100%. Any help will be greatly appreciated.

 

[Joe4]

Re: Need Help WIth A Formula That Makes Date Equal A Value In Another Cell

Enter the following formula in cell N1:

=IF(G1>0,100%,"")

The reason this works is that in Excel, dates are stored as numbers (specifically, the number of days since 1/0/1900).
It is just date formatting that makes them look like the pretty date format we expect instead of the long integer (which you can see if you change the cell formatting of any date to "General").

 

[TMILJVIPM]

Re: Need Help WIth A Formula That Makes Date Equal A Value In Another Cell

Enter the following formula in cell N1:

=IF(G1>0,100%,"")

The reason this works is that in Excel, dates are stored as numbers (specifically, the number of days since 1/0/1900).
It is just date formatting that makes them look like the pretty date format we expect instead of the long integer (which you can see if you change the cell formatting of any date to "General").

Thank you

 

[Joe4]

Re: Need Help WIth A Formula That Makes Date Equal A Value In Another Cell

You are welcome.