18 мар. 2021 г. · I want to create a What IF function for any cell that is either blank or has a date in it: For example: IF(Q2= (Blank Cell),1,2) Where blank ...

12 июн. 2012 г. · I have a cell "P1" that has a date in it. Is there a formula I can put in "P2" that can check if it is a valid date in "P1"?

9 апр. 2024 г. · The meaning of this formula is: if there is text in F1, then fill in today's date. If there is no text in F 1, empty G1.

16 июл. 2020 г. · I need to record the daily stats from K7. So whenever the cell in Column A matches the current day I want to have it recorded in Column B in the same Row.

3 янв. 2024 г. · You can use the following formula to determine if today's date is past a set due date: =IF(TODAY()>K3,"PASSED DUE","OK")

24 апр. 2023 г. · Hello,I am work on a report that has task that could be completed with a good excel formula/macro. What I am doing is comparing the 2 dates ...

8 июн. 2012 г. · Is there a way to have a spreadsheet look at a date in a cell and based on the year automatically update the year in another cell?

18 дек. 2019 г. · I am trying to create a formula in yet another cell that says "if the date range falls between 'these dates' then enter the number in 'this cell.'

24 авг. 2017 г. · Create an IF() statement that uses dates to say "If this date in this cell is sooner than 12/01/17, report back "expired".

8 июн. 2016 г. · I'm attempting to create a formula that uses IF and calculates a 3-year date. Column A cell - formula cell Column F cell - typed in date of expiration BUT only ...