Google – Spreadsheets

fail
fail

 


Data Validation

  • Select Row(Where you want to data Validation)
  • Click inset in tab
  • Click data validation in Insert drop-down Menu,
  • Set your data validation rules
  • Done

 

Google Sheets: Relative Data Validation with Dynamic Drop Downs


Function : DATEDIF()

How to calculate age from birth of date in Google sheet?

  • Formula : =IF(B2,DATEDIF(B2,TODAY(),"Y"),"")
  • Here
    • IF()  is a if function
    • B2  is the date of birth
    • DATEDIF()  is function return the difference between two dates
      • DATEDIF(start_date,end_date,unit)
    • TODAY()  is a date function it returns the current date of today.
    • Y  is returns year


 

Scripting

  • Menu > Tools > Script editor

Image Source

  • By default, it’ll open with a single Google Script file (code.gs) and a default code block, myFunction():

 

Hello World popup box

Code

 

 

Image Source

 

 



 

End Of Months

  • EOMONTH(Date(1992,08,1),0)

 

Sum Specific date

  • =sumifs(Income!F3:F,Income!A3:A,">="&C92,Income!A3:A,"<="&EOMONTH(C92,0))

 

Sum Specific Criteria

  • =SUMIF(Income!B3:B, B94, Income!F3:F)

 



Refer Link



 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

if you have any queries call us +918300026060 or WhatsApp Dismiss

0

Your Cart

%d bloggers like this: