• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If statement for dates

D

Davidrsi

New Member
I made a new Monthly award spreadsheet but i need to have it automatically move to the next month if late,accident,ect. So if driver was late on 7/15/2014 next cell would automatically enter 8/1/14 for the next available award program
 
Hi David, and welcome to the forum!

Can you give us some more information about what the layout is of your spreadsheet, and how the cells interact? You talk about late/accident and dates, but we have no idea where that information is, or in what layout (rows/columns, diagonals :p)
Is there a due date or something? Perhaps you could even upload a sample workbook, showing what you have, and highlight where you want a formula to go (and the value you want to see)
 
Luke M said:
Hi David, and welcome to the forum!

Can you give us some more information about what the layout is of your spreadsheet, and how the cells interact? You talk about late/accident and dates, but we have no idea where that information is, or in what layout (rows/columns, diagonals :p)
Is there a due date or something? Perhaps you could even upload a sample workbook, showing what you have, and highlight where you want a formula to go (and the value you want to see)
Click to expand...


I figured it out took some time but it was just this =IF(A7="","",A7-DAY(A7)+32)
 
Glad you got it working. Although I admit, I have not idea how/what your formula functions. :p
 
Hi David ,

If you can use the EOMONTH function , then the following formula will give the start date of the next month :

=EOMONTH(dt,0)+1

where dt is the date of interest.

Narayan
 
You must log in or register to reply here.
Back
Top