rutgermons
asked on
date add functions
folks
(LEFT(DAY((NOW())),2)) shows me today's day of date
I have this formula in column b , how can I add 1 day onto this formula into column c, and add 2 days into column d
(LEFT(DAY((NOW())),2)) shows me today's day of date
I have this formula in column b , how can I add 1 day onto this formula into column c, and add 2 days into column d
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi
Kanti Prasad formula will not follow the date logic. If you have 31 days in a month, +1 would be 32.
another way would be to format the cell to "DD" for Days, and then, use these formula:
=TODAY()+1
=TODAY()+2
To set day formula:
Kanti Prasad formula will not follow the date logic. If you have 31 days in a month, +1 would be 32.
another way would be to format the cell to "DD" for Days, and then, use these formula:
=TODAY()+1
=TODAY()+2
To set day formula:
Hi
the 1st post was an oversite, You need do it this way b , c , d and you don't need so many ()
=(LEFT(DAY(NOW()),2))
=(LEFT(DAY(NOW()+1),2))
=(LEFT(DAY(NOW()+2),2))
the 1st post was an oversite, You need do it this way b , c , d and you don't need so many ()
=(LEFT(DAY(NOW()),2))
=(LEFT(DAY(NOW()+1),2))
=(LEFT(DAY(NOW()+2),2))
In c and d copy and paste the below
=(LEFT(DAY((NOW())),2))+1
=(LEFT(DAY((NOW())),2))+2